package com.osgc.rf.unit;

import java.sql.Connection;

import org.apache.log4j.Category;

import com.inca.np.auth.Userruninfo;
import com.inca.np.gui.control.DBTableModel;
import com.inca.np.util.SelectHelper;
import com.osgc.rf.unit.task.RFTaskHelper;
import com.osgc.wms.service.ecode.BaseHelper;

public class DbpickHelper extends BaseHelper{
	static  protected Category logger = Category.getInstance(RFTaskHelper.class);
	public DbpickHelper(Connection con, Userruninfo userinfo) {
		super(con, userinfo);
		// TODO Auto-generated constructor stub
	}
	public String getFlag(String ownergoodsid) throws Exception{
		if(ownergoodsid==null||ownergoodsid.length()==0)return "";
		String sql = "select dbpickflag from tpl_goods where ownergoodsid = "+ownergoodsid;
		logger.debug(sql);
		DBTableModel db  = new SelectHelper(sql).executeSelect(con, 0, 1);
		if(db.getRowCount()>0)
		return db.getItemValue(0, 0);
		return "";
	}

}

